SELECT id, avatar,CONCAT(name, ' - ',  CONCAT('$',FORMAT(accounts.balance,2)) )  AS displayText, '{}' AS otherField  FROM accounts WHERE accounts.deleted = '0'
                                and  accounts.type = 'bank'   AND (name LIKE LOWER('%%') ) 
        ORDER BY id LIMIT 10 ;